room.id                                           name   host.id
1 29332969 Huge Apt in EXCELLENT LOCATION - HELLS KITCHEN  28214995
2 29485421                          Sunny Brooklyn Duplex   9503685
3 29605532 Serene art-filled apartment near Prospect Park   2681144
4 29606105                                     Le Chateau  22307859
5 29626161       Sunny room in UWS, Columbia,Central Park 222285897
6 29632401    Modern  Studio near Train, Private Entrance  59808986
        neighbourhood       room.type room.price minimum.nights
1      Hell's Kitchen Entire home/apt        350              2
2  Bedford-Stuyvesant Entire home/apt        150              2
3            Flatbush Entire home/apt         81             10
4            Canarsie    Private room         70              3
5 Morningside Heights    Private room         85              1
6       East Flatbush Entire home/apt        110              1
  number.of.reviews date.last.review number.of.reviews.per.month
1                17       2020-01-01                        0.83
2                 3       2019-01-04                        0.15
3                21       2019-12-18                        1.10
4                 3       2020-01-04                        0.15
5                72       2020-05-31                        3.52
6                49       2020-02-16                        2.39
  rooms.rent.by.the.host availibility updated.date          city       country
1                      1          179   2020-07-07 New-york-city United states
2                      2            0   2020-07-07 New-york-city United states
3                      1            0   2020-07-07 New-york-city United states
4                      3          341   2020-07-07 New-york-city United states
5                      5          177   2020-07-07 New-york-city United states
6                      3          157   2020-07-07 New-york-city United states
  latitude longitude                                          location
1 40.75950 -73.99274      United states, New-york-city, Hell's Kitchen
2 40.69119 -73.94279  United states, New-york-city, Bedford-Stuyvesant
3 40.65153 -73.95856            United states, New-york-city, Flatbush
4 40.63612 -73.89421            United states, New-york-city, Canarsie
5 40.80497 -73.96277 United states, New-york-city, Morningside Heights
6 40.64840 -73.94610       United states, New-york-city, East Flatbush

Airbnb NY Visualization

Column

Room Prices by Room Type

Taking a quick look at this box plot, it tells us about the spread and median prices for different types of rooms. Entire homes or apartments have the widest price range and the highest median price, while shared rooms are the cheapest and have less variation in price. The dots outside the main plot show the outliers, which are unusually high or low prices compared to the rest. It’s interesting to note that we see quite a few outliers for entire homes and private rooms.

Distribution of Room Prices

Count of Room Types

Room Price vs. Number of Reviews

Spatial Distribution of Airbnb Listings

Map of listings